UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N7QJ3OJD1nxjmPimQMPk9LOaRx/4MVk2Kt4HEwXtgHY='
WHERE
key_id = '0747ab9f1e16f1192d7bcab3447661750736b7b0a8ac425d372637e4a9c6d255'
AND (
token = 'N7QJ3OJD1nxjmPimQMPk9LOaRx/4MVk2Kt4HEwXtgHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)