UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'W1+15rLe4hq68YrPKOsbluRE/YVquRz/+XuwbPWepSU=' 
WHERE 
  key_id = 'c3f23c19d83c2707d8fc74013f6c9e3c8ead8a21e9047b3799cc3ce2ec85d85d' 
  AND (
    token = 'W1+15rLe4hq68YrPKOsbluRE/YVquRz/+XuwbPWepSU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053