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

Query time 0.00037