UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7wyHilGU3CGpUaLv7Xu9k+aokeP8IeoElp2R3m74xg='
WHERE
key_id = 'ec20b02add9749fcc96353e3540a26833c46f78fed2df030a712dc920417d0bf'
AND (
token = 'L7wyHilGU3CGpUaLv7Xu9k+aokeP8IeoElp2R3m74xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)