UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1GGR2dT8M1FRSi10B8xcdUly7zedFRHXGIWVTY4vaN0='
WHERE
key_id = '6ac7b9e93d7460cb02de7fa998f2921c56fb7752783139596ff198f275b55110'
AND (
token = '1GGR2dT8M1FRSi10B8xcdUly7zedFRHXGIWVTY4vaN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)