UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fUQe1KfaWjD6KYOAHxZBj0OW9T7jD1ab7N6pXX3wWdo='
WHERE
key_id = 'bbf178b210cbc3746cb8972ad2e7841ae5d223299275e6c430c744a983535ef4'
AND (
token = 'fUQe1KfaWjD6KYOAHxZBj0OW9T7jD1ab7N6pXX3wWdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)