UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7CrpYv9g7TMmh95lShZGdP2sWzu5/YXMkSwgDThtfg='
WHERE
key_id = 'de3c87249bf9738cebbf4a6ee2294a056ade76f27d222c9fc3a7c4d924205322'
AND (
token = 'a7CrpYv9g7TMmh95lShZGdP2sWzu5/YXMkSwgDThtfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)