UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aiPMesEO/VSRRi4bMNpbAFAxGH894vDNKaUFV/Oo3m8=' 
WHERE 
  key_id = '20345605a11a3d5d0174c72eb3486d7008f74f16936dd3e9a7940ab117559268' 
  AND (
    token = 'aiPMesEO/VSRRi4bMNpbAFAxGH894vDNKaUFV/Oo3m8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021