UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'b1+IFt7ZdN32HOJBIQpa2M3pPTv+M8VA+efDxaW6sIY=' 
WHERE 
  key_id = 'd0fd33c895078ebc8b2c3d3205abc9d7366b94d7f491ac50ecacaff907c4c302' 
  AND (
    token = 'b1+IFt7ZdN32HOJBIQpa2M3pPTv+M8VA+efDxaW6sIY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024