UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9onmdcXQRfPicFL4VcBO9LnYaE4UKM85ssBJCl0Wmr0='
WHERE
key_id = 'e34d9b5f65675008214409d26640518a2805b4b047219b6b04846c317ede0c07'
AND (
token = '9onmdcXQRfPicFL4VcBO9LnYaE4UKM85ssBJCl0Wmr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)