UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ppntk4s6MFsArorC41amWA0vqd88jv12wsreQysbZUA=' 
WHERE 
  key_id = 'b028c14341803afc8f0d566fd3832ed2e32e894b86f7160a1994e6d653767ac7' 
  AND (
    token = 'Ppntk4s6MFsArorC41amWA0vqd88jv12wsreQysbZUA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037