UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J1H1idd4VpuwwQcHQx4SmvnZZ1v2czGM6MpGdjp6muQ='
WHERE
key_id = '5563f560b2960b728486d0e04d761a8a3afba2f42a9a2c2a8634f22ea6807de2'
AND (
token = 'J1H1idd4VpuwwQcHQx4SmvnZZ1v2czGM6MpGdjp6muQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)