UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JHOnk9v9SVMUsvDU9pZTr2ehwrpjYiJPAnxQ08UkwCA='
WHERE
key_id = '99e3860f6d576684dc742b3c23720e5bcecd506066b2ae8ad0f245b0591ff9a7'
AND (
token = 'JHOnk9v9SVMUsvDU9pZTr2ehwrpjYiJPAnxQ08UkwCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)