UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cJc7asLj1jNly/RCdKh+vPbvm1/iLzOqW+Syd3g6p0o='
WHERE
key_id = 'fe308f291f9800f04a64ad9fc415785bd8b04bd4c0bdf86a8d543005fed2d933'
AND (
token = 'cJc7asLj1jNly/RCdKh+vPbvm1/iLzOqW+Syd3g6p0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)