UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPinSv6qkMpzn2CU2QuRCJ0TDxPx5k7BwayagJzx7oM='
WHERE
key_id = '170ddee4bbbda68522b1ef88108a2ab11b9e41e9ed84ed822896e216aa87afbd'
AND (
token = 'sPinSv6qkMpzn2CU2QuRCJ0TDxPx5k7BwayagJzx7oM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)