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