UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'okylnxfnm3wD80eZ4s8JK2Au4a5S1zxVFubzeJffKyU=' 
WHERE 
  key_id = '3ed2769908918efeb50e01433768cd9f4fbf1b5f66f321d3945bd0cf85a08ef5' 
  AND (
    token = 'okylnxfnm3wD80eZ4s8JK2Au4a5S1zxVFubzeJffKyU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027