UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'C3HWcgvRWhGJHB+nW+Zd1vQh4UHi8Z3tX1b5g6Smnic=' 
WHERE 
  key_id = 'bd5f3185be152786f5df1f0523ef2a9c6d93ceb9f8038faab1a038acf51d6425' 
  AND (
    token = 'C3HWcgvRWhGJHB+nW+Zd1vQh4UHi8Z3tX1b5g6Smnic=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032