UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eHN1cTHG/T0wGdFw6tKnqLwbzVzKjFUJj9qsjUiZo1s='
WHERE
key_id = 'd02b12b41fc5811dd3035f17196f964e6156ef3884dc493d32e9caf30b6a2b94'
AND (
token = 'eHN1cTHG/T0wGdFw6tKnqLwbzVzKjFUJj9qsjUiZo1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)