UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'McJ/xPXFKMGWu1zDgFOuUMz3DriuCIvXRNOp51f6oJ4='
WHERE
key_id = '0e61fa468c82e454766769ce3326ce56e841b9e0aa7e3b238dd555941295acf3'
AND (
token = 'McJ/xPXFKMGWu1zDgFOuUMz3DriuCIvXRNOp51f6oJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)