UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpPFHFGFbk+FdcSJQp3eSs6EyVRcav5lzGpmJqSnBtQ='
WHERE
key_id = '0eae9f20bf4a57da73c4316db055103623e66f4511489cd66c3446feebc2f102'
AND (
token = 'zpPFHFGFbk+FdcSJQp3eSs6EyVRcav5lzGpmJqSnBtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)