UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6C9Fj9PNnyAeGH3Ee6QNhdJyKdlnj1knlwlgRD8big='
WHERE
key_id = 'a4bbdeabc2583b4c0d92f967660bf63d03afc54322ab814e5bed71e5489f0730'
AND (
token = 'K6C9Fj9PNnyAeGH3Ee6QNhdJyKdlnj1knlwlgRD8big='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)