UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/7l3jA8KnQDg6mws04s7sqPKtBw9MxBbBkMt1TzcKKk=' 
WHERE 
  key_id = '50b66dcffb94fe2d01b1414871fc48d6b9b9b95a4e8c1b5771aa8b01b4a9b32f' 
  AND (
    token = '/7l3jA8KnQDg6mws04s7sqPKtBw9MxBbBkMt1TzcKKk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029