UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HY7OmRUJKJjXtYYcHwquqc0KWuIyFIJjU91jHabP/Po='
WHERE
key_id = 'd0fb72068cbcf50a5f056d61e497cb1b3e76b350e3f50dfae346607285632f77'
AND (
token = 'HY7OmRUJKJjXtYYcHwquqc0KWuIyFIJjU91jHabP/Po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)