UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NtrLbXqtwXEVPIzu3XQPqYMpfAYyhbb+gGCuuF+auB4='
WHERE
key_id = 'd942a356082034af0d5434af09fa05dd90e60c1b691f7857859abb2d3b35f6f4'
AND (
token = 'NtrLbXqtwXEVPIzu3XQPqYMpfAYyhbb+gGCuuF+auB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)