UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rUqUg8Kf9wOzX+rub8NH/8TLUla2HxQeSwPNwufB3Sg=' 
WHERE 
  key_id = '266094c07d212d0c754ced6dc859c34cb7fd59118694875b07fbf3199bf31047' 
  AND (
    token = 'rUqUg8Kf9wOzX+rub8NH/8TLUla2HxQeSwPNwufB3Sg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047