UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Dp3y4R246NksLo8c8z6DFpuH1WD9TxxUVpUE6JXkcs='
WHERE
key_id = '6678b2bddfa45210f7fa10cf350cf5697a39ecc630c656ef7a0aa477d15edcc6'
AND (
token = '9Dp3y4R246NksLo8c8z6DFpuH1WD9TxxUVpUE6JXkcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)