UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgMi1AXgihSiYvIDxAZbF25aBpxn0MGW3NFOUxDUIyE='
WHERE
key_id = '25562ab29d264eff71757389810bf840e345bfc1543106d9a356e18e05ebae6a'
AND (
token = 'KgMi1AXgihSiYvIDxAZbF25aBpxn0MGW3NFOUxDUIyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)