UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3S7Enaggha3KOaoJZFvor6FSj2crqBW5E3Ne8QsFnsw='
WHERE
key_id = '9cd5d4706de6d63e03bb048b51c4bb01e44162794aaec8357a1a60ac49de72e7'
AND (
token = '3S7Enaggha3KOaoJZFvor6FSj2crqBW5E3Ne8QsFnsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)