UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T3gxFYphiH9NTC0K7rVLfiNAPuOaPS27cTmW9m9+MoY='
WHERE
key_id = 'fe2758e2dbd65e3f403b3c40642382f21978433a2c84d0d150c6b454ad4267f2'
AND (
token = 'T3gxFYphiH9NTC0K7rVLfiNAPuOaPS27cTmW9m9+MoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)