UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bb6VUR64+4WlPYf6grJCqIkDC21M9y2/L1fevLcxKP4='
WHERE
key_id = '4be7f1bf043b4ffa644ab58de08cd42470fe08e841629a40f3990484b1300e2c'
AND (
token = 'bb6VUR64+4WlPYf6grJCqIkDC21M9y2/L1fevLcxKP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)