UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PqSmX+8NwEe0L3oaceBB1Sguyri3+3NVRL3CaPFO8m4='
WHERE
key_id = 'c473c5e3d0f5857a7a5fd890719728951df3f430769e595243fede416421995e'
AND (
token = 'PqSmX+8NwEe0L3oaceBB1Sguyri3+3NVRL3CaPFO8m4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)