UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MZZl1BLlMoHIeaBOlXsU90lhHA/q0ROelI5d1HhphoA='
WHERE
key_id = '0e58d4892f6dba136415162fa2572bbf20ea6ce89b3c8df2351e7993f71d9d43'
AND (
token = 'MZZl1BLlMoHIeaBOlXsU90lhHA/q0ROelI5d1HhphoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)