UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5VmcZqaIT4B2a8DSYV35bmA3FToZVsX8vSHa5KLlRe4=' 
WHERE 
  key_id = 'a265721111aa3b7592aec42a09d486c395a424b431b53d6ec085242ed4360d7d' 
  AND (
    token = '5VmcZqaIT4B2a8DSYV35bmA3FToZVsX8vSHa5KLlRe4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033