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

Query time 0.00035